package com.ruoyi.system.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.SysServiceWorkOrderBi;

/**
 * SysServiceWorkOrderBiMapper接口
 * 
 * @author SYF
 * @date 2025-06-04
 */
public interface SysServiceWorkOrderBiMapper 
{
    /**
     * 查询SysServiceWorkOrderBi
     * 
     * @param year SysServiceWorkOrderBi主键
     * @return SysServiceWorkOrderBi
     */
    public SysServiceWorkOrderBi selectSysServiceWorkOrderBiByYear(String id);

    /**
     * 查询SysServiceWorkOrderBi列表
     * 
     * @param sysServiceWorkOrderBi SysServiceWorkOrderBi
     * @return SysServiceWorkOrderBi集合
     */
    public List<SysServiceWorkOrderBi> selectSysServiceWorkOrderBiList(SysServiceWorkOrderBi sysServiceWorkOrderBi);

    /**
     * 新增SysServiceWorkOrderBi
     * 
     * @param sysServiceWorkOrderBi SysServiceWorkOrderBi
     * @return 结果
     */
    public int insertSysServiceWorkOrderBi(SysServiceWorkOrderBi sysServiceWorkOrderBi);

    /**
     * 修改SysServiceWorkOrderBi
     * 
     * @param sysServiceWorkOrderBi SysServiceWorkOrderBi
     * @return 结果
     */
    public int updateSysServiceWorkOrderBi(SysServiceWorkOrderBi sysServiceWorkOrderBi);

    /**
     * 删除SysServiceWorkOrderBi
     * 
     * @param year SysServiceWorkOrderBi主键
     * @return 结果
     */
    public int deleteSysServiceWorkOrderBiByYear(String year);

    /**
     * 批量删除SysServiceWorkOrderBi
     * 
     * @param years 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSysServiceWorkOrderBiByYears(String[] years);

    public List<Map<String,Object>> selectKfhfOrders();

    public List<Map<String,Object>> selectKfhfOrdersInfo(SysServiceWorkOrderBi sysServiceWorkOrderBi);
}
